<?xml version="1.0" encoding="utf-8" ?>
<items>
	<item name="360" path="C:\Users\jdd01\AppData\Roaming\360se6\User Data\Default\History">
		<sql name="downloads">SELECT downloads.id, downloads.full_path, downloads.url, datetime(substr(start_time, 1, 11),'unixepoch','localtime') start_time, downloads.received_bytes, downloads.total_bytes, downloads.state,datetime(substr(end_time,1,11),'unixepoch','localtime') end_time, downloads.referrer FROM downloads where datetime(substr(start_time-date('now','-10 day'),1, 11) ,'unixepoch','localtime')>date('now','-10 day')  order by  start_time desc </sql>
		<sql name="histrory">SELECT urls.id, urls.title, urls.url, urls.visit_count, urls.typed_count,datetime(substr(last_visit_time, 1, 11) - 11644473600,'unixepoch','localtime') last_visit_time FROM urls where datetime(substr(last_visit_time-date('now','-1 day'),1, 11) - 11644473600,'unixepoch','localtime')>date('now','0 day')  order by  last_visit_time desc</sql>
	</item>
	<item name="google" path="f:\Users\jdd01\AppData\Local\Google\Chrome\User Data\Default\History">

		<sql name="downloads">SELECT downloads.id, downloads.current_path, downloads.target_path, datetime(( substr(start_time, 1, 11) - 11644473600 ), 'unixepoch', 'localtime' ) start_time, downloads.received_bytes, downloads.total_bytes, downloads.state, downloads.danger_type, downloads.interrupt_reason, datetime(( substr(end_time, 1, 11) - 11644473600 ), 'unixepoch', 'localtime' ) end_time, downloads.opened FROM downloads  where datetime(substr(start_time-date('now','-1 day'),1, 11) - 11644473600,'unixepoch','localtime')>date('now','0 day')  order by  start_time desc </sql>
		<sql name="history">SELECT urls.id, urls.title, urls.url, urls.visit_count, urls.typed_count, datetime(( substr(last_visit_time, 1, 11) - 11644473600 ), 'unixepoch', 'localtime' ) last_visit_time, urls.hidden, urls.favicon_id FROM urls where datetime(substr(last_visit_time-date('now','-1 day'),1, 11) - 11644473600,'unixepoch','localtime')>date('now','0 day')  order by  last_visit_time desc</sql>
		<sql name="downloads_url">SELECT b.id,a.url, b.current_path, b.target_path, datetime(( substr(start_time, 1, 11) - 11644473600 ), 'unixepoch', 'localtime' ) start_time, b.received_bytes, b.total_bytes, b.state, b.danger_type, b.interrupt_reason, datetime(( substr(end_time, 1, 11) - 11644473600 ), 'unixepoch', 'localtime' ) end_time, b.opened FROM downloads b , downloads_url_chains a ON a.id = b.id   where datetime(substr(b.start_time-date('now','-1 day'),1, 11) - 11644473600,'unixepoch','localtime')>date('now','0 day')  order by  b.start_time desc</sql>
	</item>
	<item name="firefoxplaces_sqlite" path="f:\Users\jdd01\AppData\Roaming\Mozilla\Firefox\Profiles\752aure0.default\places.sqlite">
		<sql name="history">SELECT moz_places.id, moz_places.url, moz_places.title, moz_places.visit_count, moz_places.favicon_id, moz_places.frecency,datetime(last_visit_date,'unixepoch','localtime') last_visit_date, moz_places.guid FROM moz_places</sql>
	</item>
	<item name="firefoxdownloads_sqlite" path="f:\Users\jdd01\AppData\Roaming\Mozilla\Firefox\Profiles\752aure0.default\downloads.sqlite">
		<sql name="history">SELECT moz_downloads.id, moz_downloads.name, moz_downloads.source, moz_downloads.target, moz_downloads.tempPath,datetime(startTime,'unixepoch','localtime') startTime, datetime(endTime,'unixepoch','localtime') endTime, moz_downloads.referrer, moz_downloads.entityID, moz_downloads.currBytes, moz_downloads.maxBytes, moz_downloads.mimeType, moz_downloads.preferredApplication, moz_downloads.preferredAction, moz_downloads.autoResume, moz_downloads.guid FROM moz_downloads</sql>
	</item>
</items>
